Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$PROXY_ARCHIVEDLOG

`V$PROXY_ARCHIVEDLOG` contains descriptions of archived log backups which are taken with Proxy Copy. Each row represents a backup of one archived log.

Column | Datatype | Description
--- | --- | ---
`RECID` | `NUMBER` | Proxy copy record ID
`STAMP` | `NUMBER` | Proxy copy record stamp
`DEVICE_TYPE` | `VARCHAR2(17)` | Type of the device on which the copy resides
`HANDLE` | `VARCHAR2(513)` | Proxy copy handle identifies the copy for restore
`COMMENTS` | `VARCHAR2(81)` | Comment returned by the operating system or storage subsystem. This value is informational only. It is not needed for restore.
`MEDIA` | `VARCHAR2(65)` | Name of the media on which the copy resides. This value is informational only. It is not needed for restore.
`MEDIA_POOL` | `NUMBER` | Media pool in which the copy resides. This is the same value that was entered in the `POOL` operand of the Recovery Manager `BACKUP` command.
`TAG` | `VARCHAR2(32)` | Proxy copy tag
`STATUS` | `VARCHAR2(1)` | Indicates the status of the copy: `A` - Object is available `D` - Object is deleted `X` - Object has been "cross-checked" and found not to exist. A subsequent "delete expired" command will change the status to `D`. If, for some reason, the object really does still exist, then a subsequent "cross-check" command will change the status back to `A`.
`DELETED` | `VARCHAR2(3)` | Indicates whether the record has been deleted (`YES`) or not (`NO`)
`THREAD#` | `NUMBER` | Redo thread number
`SEQUENCE#` | `NUMBER` | Redo log sequence number
`RESETLOGS_CHANGE#` | `NUMBER` | Resetlogs change number of the database when this log was written
`RESETLOGS_TIME` | `DATE` | Resetlogs time of the database when this log was written
`FIRST_CHANGE#` | `NUMBER` | First change number in the archived log
`FIRST_TIME` | `DATE` | Timestamp of the first change
`NEXT_CHANGE#` | `NUMBER` | First change number in the next log
`NEXT_TIME` | `DATE` | Timestamp of the next change
`BLOCKS` | `NUMBER` | Size of the archived log (in blocks)
`BLOCK_SIZE` | `NUMBER` | Redo log block size
`START_TIME` | `DATE` | Starting time
`COMPLETION_TIME` | `DATE` | Completion time
`ELAPSED_SECONDS` | `NUMBER` | Number of elapsed seconds
`RMAN_STATUS_RECID` | `NUMBER` | Owning `V$RMAN_STATUS` record ID
`RMAN_STATUS_STAMP` | `NUMBER` | Owning `V$RMAN_STATUS` record stamp